CREATE TABLE jms_dm.dm_dev_repair_network_monitor_network_summary_dt
(
    scan_network_code varchar(100) COMMENT "站点code",
    scan_network_name varchar(100) COMMENT "站点name",
    date_time         date COMMENT "日期",
    cen_wxout_num     int COMMENT "中心维修出库数量",
    net_wxin_num      int COMMENT "维修入库",
    net_wxou_num      int COMMENT "维修出库数量",
    cen_wxin_num      int COMMENT "中心维修入库数量",
    net_bf_num        int COMMENT "报废数量维修",
    net_wxp_num       int COMMENT "无芯片数量维修",
    net_xpth_num      int COMMENT "芯片替换数量维修",
    net_wxpd_num      int COMMENT "维修盘点数量维修"
) ENGINE=OLAP
DUPLICATE KEY(scan_network_code)
COMMENT "设备中转件量分析维修点汇总"
PARTITION BY RANGE(date_time)
(START ('2023-12-01') END ('2024-01-20') EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(scan_network_code) BUCKETS 1
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-180",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1",
"in_memory" = "false",
"storage_format" = "V2",
"enable_persistent_index" = "false"
);